Columns

VIDEO | Columns and Registers

Within each register, you can move, sort, filter and group your columns to view the information the way you need to see it.

Move Columns

You can move columns by selecting a column header and using drag-and-drop. If there are columns on the register that you don’t use, you can hide and unhide them from view, as needed.

Step by Step — Move Columns

  1. In the CBS, click on the Currency column header and drag the column to the left, dropping it to the right of the Description column.

  2. Hide the Optional Code column by dragging the Optional Code column header down until a black X appears, then let go.

    • The Optional Code is now hidden from view

    • To unhide a column, right click on any column header and select Column Chooser; a Customization window appears, which contains all the hidden columns in that register

  3. Find the column you want to unhide and drag-and-drop it to the location where you want it to go.

    • You can also unhide a column using the Go To Column feature

  4. Right click on a column header and select Go To Column.

  5. Click on the drop-down menu and select the column you want to unhide.

  6. Click OK.

Sort and Filter Columns

You can sort and filter your columns to drill down to specific information.

Step by Step — Sort Columns

You can sort on any column by clicking once on the column header.

  1. In the CBS Register, click on the Total Cost (Forecast) column to sort the column in ascending order (e.g., 1 to 10, A to Z).

  2. Click the Total Cost (Forecast) column a second time to sort in descending order (e.g.,10 to 1, Z to A).

Use Ctrl-click to unsort a column and reset it to its original state.

Step by Step — Filter Columns

  1. In the CBS, hover over the Unit of Measure column header for the filter icon to appear.

  2. Click on the filter icon in the Unit of Measure column to select a filter value.

    • From the filter list, you can select any of the values defined for that column or you can use one of the predefined values (Custom, Blanks, Non blanks).

  3. Make your selection, then click OK.

  4. To clear the filter, click on the red X at the bottom of the form or click on the filter icon on the header of the column you filtered and select (All), then click OK.

Filter Editor Overview

The Filter Editor displays conditions and groups as a tree branching system.

The Filter Editor grouping feature allows you to increase the amount of And/Or statements that originated from the first selected And statement. When you add a new Group, a new Condition is automatically added to that Group.

With each additional Condition statement, you will need to select an operator and a value in order for your customized filter to take effect on your chosen column. Many new operators have been added to this version as shown in the screenshot below:

Step by Step — Filter Editor

  1. In the CBS, hover over the Unit of Measure column header for the filter icon to appear.

  2. Click the filter icon in the Unit of Measure column to select a filter value.

  3. Select the Filter Editor button. The Filter Editor data box appears.

    • By default, an And statement is created with a Begins with operator and a blank value.

  4. Select your preferred operator and then enter in your preferred value.

  5. To add additional And/Or statements, select the word And in the top left corner. A drop down appears.

  6. Choose which And/Or statement to add and then select the preferred operator.
  7. Enter in your preferred value to complete your additional statement.
  8. Select the X to delete a single statement.
  9. Select the And statement in the top left corner to begin clearing all And/Or statements.
  10. From the drop down, select the option Clear All.
  11. Once done, select Apply and then click OK.

Group Columns

Sometimes you may want to organize your information into groups. Instead of filtering your information down to one value (e.g., unit of measure = Ton), you can look at your information with a separate group for each value (e.g., a group for Tons, a group for Cubic Feet, etc.).

Step by Step — Group Columns

  1. From the CBS register, group the Unit of Measure column by dragging it into the grouping area (where it says “Drag columns here to group”).

    • Notice that the cost items in the register are now grouped together by their units of measure, and each group of cost items is subtotalled by costs, hours, quantities, etc.

  2. To ungroup, right click in the grouping area and select Clear Grouping

    • The column returns to its original location

      You can group by more than one column to have multiple grouping levels.

Saved Views

Once you have set up a view the way you like it, you can save the view so you won’t have to configure it again later. InEight Estimate also comes with some pre-built views to help you organize the screen the way you want to see it.

Views are accessed from the Saved Views menu in the top right portion of a register.

The following steps assume you have made changes to your register view and want to save it for future use.

Step by Step — Create a Saved View

  1. In the CBS register, click on the Saved Views drop-down menu and the Save disc icon appears.

  2. Click on the Save disc icon.

    • The Save Current View window appears

  3. Enter the View Name, then select OK.

    • The new view displays in the drop-down menu

Saved views are user-specific; you will only see your own saved views when you are logged in.

Register Running Totals

You can select multiple rows in a register and see the sum total amount at the bottom of the register.

For example, you can hold down the CTRL key and multi-select cost items 2.1.1, 2.2.1, and 2.3.2 in the CBS register, you can see the sum of the three selected cost items toward the bottom row of the register.

Estimate calculates subtotals for quantities when the UOMs match. Superior cost items are not included in the subtotals to avoid any double counting in the subtotal.

It is not necessary to export data to Microsoft Excel and run separate calculations to better understand costs of multiple items. The sigma symbol shows in the subtotaled row to indicate it is the total of the selected rows.